Cannot delete array due to array protected.
Cause:
Any or all of the areas selected for deletion are included in a protected array.
Solution:
Copy the entire array, select 'Paste Special...' from the 'Edit' menu, and select the 'Values' radio button.
1) Select all the cells contained in the array.
2) Select the 'Edit' menu and select 'Copy'.
3) Select the 'Edit' menu and select 'Paste Special...'.
4) Select the 'Values' radio button from the 'Paste' window.
5) Click 'OK'. (The array is replaced with values.)
6) Do one of the following:
a) Click outside the selection to deselect the highlighted cells.
b) Select the 'Edit' menu and select 'Clear' to delete the contents of the selected cells.
